<!doctype HTML public "-//W3C//DTD HTML 4.0 Frameset//EN">
<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=utf-8">
<meta name="generator" content="Adobe RoboHelp - www.adobe.com">
<title>Applying selections as filters or slices</title>
<link rel="stylesheet" href="RoboHTML_ns.css"><script type="text/javascript" language="JavaScript" title="WebHelpSplitCss">
<!--
if (navigator.appName !="Netscape")
{   document.write("<link rel='stylesheet' href='RoboHTML.css'>");}
//-->
</script>
<style type="text/css">
<!--
img_whs1 { border:none; width:251px; height:184px; float:none; border-style:none; }
img_whs2 { border:none; width:248px; height:185px; float:none; border-style:none; }
img_whs3 { border:none; width:255px; height:184px; float:none; border-style:none; }
-->
</style><script type="text/javascript" language="JavaScript" title="WebHelpInlineScript">
<!--
function reDo() {
  if (innerWidth != origWidth || innerHeight != origHeight)
     location.reload();
}
if ((parseInt(navigator.appVersion) == 4) && (navigator.appName == "Netscape")) {
	origWidth = innerWidth;
	origHeight = innerHeight;
	onresize = reDo;
}
onerror = null; 
//-->
</script>
<style type="text/css">
<!--
div.WebHelpPopupMenu { position:absolute; left:0px; top:0px; z-index:4; visibility:hidden; }
-->
</style><script type="text/javascript" language="javascript1.2" src="whmsg.js"></script>
<script type="text/javascript" language="javascript" src="whver.js"></script>
<script type="text/javascript" language="javascript1.2" src="whproxy.js"></script>
<script type="text/javascript" language="javascript1.2" src="whutils.js"></script>
<script type="text/javascript" language="javascript1.2" src="whlang.js"></script>
<script type="text/javascript" language="javascript1.2" src="whtopic.js"></script>
</head>
<body><script type="text/javascript" language="javascript1.2">
<!--
if (window.gbWhTopic)
{
	if (window.addTocInfo)
	{
	addTocInfo("Creating and modifying documents and dashboards\nDesigning dynamic enterprise dashboards\nProviding interactivity to users: Selectors\nApplying selections as filters or slices");
addButton("show",BTN_TEXT,"Show","","","","",0,0,"","","");

	}
	if (window.writeBtnStyle)
		writeBtnStyle();

	if (window.writeIntopicBar)
		writeIntopicBar(1);

	if(1)
	{
	
	}

	if (window.setRelStartPage)
	{
	setRelStartPage("MicroStrategy_Web_Help.htm");

		autoSync(1);
		sendSyncInfo();
		sendAveInfoOut();
	}
}
else
	if (window.gbIE4)
		document.location.reload();

//-->
</script>
<h1>Applying selections as filters or slices</h1>
<h2>Before you begin</h2>
<p class=Tip-Note-Text>You should be familiar with the various properties 
 that define how a selector looks and what it controls, such as target 
 and source. See 
<a href="Defining_a_selector.htm">Defining selectors</a> 
 for descriptions.</p>
<p>
<a href="#To_apply_selections_as_filters_or_slices">Steps to apply selections 
 as filters or slices</a></p>
<p>The selections a user makes in a selector can either filter or slice 
 the selector's target:</p>
<ul>
<li class=p-First-Bullet-Do-Not-Type-Text><p class=First-Bullet-Do-Not-Type-Text>&nbsp;</p></li>
	
<li class=p-Topic-Text-Bulleted><p class=Topic-Text-Bulleted><span 
 style="font-weight: bold;"><B>Filtering</B></span> means that the data for the 
 current selection is calculated only when it is requested by the user. 
 The selections are used to filter the underlying dataset before the metric 
 values are aggregated at the level of the Grid/Graph that is displayed 
 in the document. If the source attribute is not included in the Grid/Graph, 
 the metric values from all the selected elements are aggregated and shown 
 at the level specified in the Grid/Graph.</p></li>
	
<li class=p-Topic-Text-Bulleted><p class=Topic-Text-Bulleted><span 
 style="font-weight: bold;"><B>Slicing</B></span> means that the data for each 
 available item in the selector is calculated in advance when the document 
 is first displayed. The selections are used to determine which slices 
 of data are combined and shown in the Grid/Graph. Even if the source attribute 
 is not included in the Grid/Graph, the data is still sliced at the level 
 of the source attribute, and therefore the metric values from multiple 
 selected items are not added together. Instead, the data for each selected 
 element is shown separately in the Grid/Graph, the same as if the source 
 attribute had been included in the Grid/Graph.</p></li>
</ul>
<p>For example, the dataset report of a document contains Region, Year, 
 and the Revenue metric. A Grid/Graph displays Year and Revenue only, and 
 is targeted by a selector with Region as its source. The selector is defined 
 to slice the data. When Central is selected, three rows, one for each 
 year, are displayed, as shown below:</p>
<p><img src="images/slicingselector_Central.gif" x-maintain-ratio="TRUE" width="251px" height="184px" border="0" class="img_whs1"></p>
<p>If you select Mid-Atlantic as well as Central, six rows are displayed, 
 two for each year, as shown below:</p>
<p><img src="images/slicingselector_CMA.gif" x-maintain-ratio="TRUE" width="248px" height="185px" border="0" class="img_whs2"></p>
<p>This occurs because the selector slices the data by region before the 
 user selections are made, and cannot aggregate the slices for multiple 
 regions. </p>
<p>If you change the selector to filter rather than slice the data, the 
 yearly revenue is aggregated across the selected regions. The yearly revenue 
 is calculated by adding the Central and Mid-Atlantic values for each year, 
 and only one row for each year is displayed in the Grid/Graph, as shown 
 below:</p>
<p><img src="images/filteringselector.gif" x-maintain-ratio="TRUE" width="255px" height="184px" border="0" class="img_whs3"></p>
<p>Other important differences between filtering and slicing selectors 
 are described below:</p>
<ul>
<li class=p-First-Bullet-Do-Not-Type-Text><p class=First-Bullet-Do-Not-Type-Text>&nbsp;</p></li>
	
<li class=p-Topic-Text-Bulleted><p class=Topic-Text-Bulleted>Slicing 
 allows the total to be displayed as an item in the selector. A filtering 
 selector does not display the total as a selector item. </p></li>
	
<li class=p-Topic-Text-Bulleted><p class=Topic-Text-Bulleted>Slicing 
 allows you to specify that the selector automatically uses a default selection 
 when other changes in the document cause the selection made by the user 
 to return no data. Default selections are not available for filtering 
 selectors. (For background information on default selections, see 
<a href="Running_and_analyzing_documents.htm">Determining 
 how the target of a selector displays when no data exists</a>.)</p></li>
	
<li class=p-Topic-Text-Bulleted><p class=Topic-Text-Bulleted>Slicing 
 is performed on Intelligence Server in View Mode in MicroStrategy Web 
 and on the client in Flash Mode in MicroStrategy Web. Filtering is performed 
 on the Intelligence Server in both modes. This means that when a user 
 chooses different items in a selector, a call is made to the web server 
 to update the document, except when a slicing selector is used in Flash 
 Mode. In that case, the web server is not called, which can make the document 
 run faster as users change selections. In contrast, a filtering selector 
 can speed up the initial load time of a document in Flash Mode, since 
 all the slices do not need to be initially downloaded to the client.</p></li>
	
<li class=p-Topic-Text-Bulleted><p class=Topic-Text-Bulleted>When a 
 document is viewed off-line (exported to Flash, in a subscription, or 
 in MicroStrategy Office):</p></li>
</ul>
<ul>
<li class=p-Topic-Text-Bulleted-2><p class=Topic-Text-Bulleted-2>If 
 a selector is applied using filtering, only the data for the current selections 
 are included in the document. An off-line user cannot change the selector 
 and update the target. </p></li>
	
<li class=p-Topic-Text-Bulleted-2><p class=Topic-Text-Bulleted-2>If 
 a selector is applied using slicing, all the slices, and therefore all 
 the data, are included in the document. An off-line user can change the 
 selector and update the target.</p></li>
	<ul>
<li class=p-Steps-No-Number-Indent><p class=Steps-No-Number-Indent>To 
 continue with the yearly regional revenue document described above, the 
 selector is applied as a filter. Only Central is selected, and the document 
 is exported to an MHT file to be used off-line, without using MicroStrategy. 
 The MHT file contains only the data for Central, and no other selections 
 can be made. </p></li>
		
<li class=p-Steps-No-Number-Indent><p class=Steps-No-Number-Indent>If 
 the selector is applied as a slice instead, all the data is sliced and 
 included in the MHT file. Even if only the Central region is selected 
 when the document is exported, you can use the selector in the MHT file 
 and display other regions. (For background information on exporting dashboards 
 to Flash, see 
<a href="Export_a_document.htm">Exporting a document</a>.)</p></li>
	</ul>
</ul>
<h2>
<a name=To_apply_selections_as_filters_or_slices></a>To apply selections 
 as filters or slices for a specific selector</h2>
<p><span style="font-weight: bold;"><B>Note</B></span>: If you do not define whether 
 a particular selector slices or filters the data, the document-level property 
 is used. For instructions to set it, see 
<a href="#To_apply_selections_as_filters_or_slices_(document-level)">To 
 apply selections as filters or slices (document-level)</a>.</p>
<ol><ul>
<li class=p-First-Steps-Do-Not-Type-Text><p class=First-Steps-Do-Not-Type-Text>&nbsp;</p></li>
	</ul>
	
<li class=p-Steps><p class=Steps>Open the document in the Document 
 Editor</p></li>
	
<li class=p-Steps><p class=Steps>Right-click the selector to update, 
 and select <span style="font-weight: bold;"><B>Properties</B></span>. The Properties 
 dialog box opens.</p></li>
	
<li class=p-Steps><p class=Steps>Click the <span style="font-weight: bold;"><B>Selector</B></span> 
 tab.</p></li>
	
<li class=p-Steps><p class=Steps>Do one of the following:</p></li>
	<ul>
<li class=p-Steps-Bulleted-1><p class=Steps-Bulleted-1>To apply 
 the selections as a filter, select the <span style="font-weight: bold;"><B>Apply 
 selections as a filter</B></span> check box.</p></li>
		
<li class=p-Steps-Bulleted-1><p class=Steps-Bulleted-1>To apply 
 the selections as a slice, clear the <span style="font-weight: bold;"><B>Apply 
 selections as a filter</B></span> check box.</p></li>
	</ul>
	
<li class=p-Steps><p class=Steps>Click <span style="font-weight: bold;"><B>OK</B></span> 
 to return to the document.</p></li>
</ol>
<h2>
<a name="To_apply_selections_as_filters_or_slices_(document-level)"></a>To 
 apply selections as filters or slices (document-level)</h2>
<p>This document-level property is applied to all new selectors that do 
 not have a target and have not been individually defined as filtering 
 or slicing. </p>
<ol><ul>
<li class=p-First-Steps-Do-Not-Type-Text><p class=First-Steps-Do-Not-Type-Text>&nbsp;</p></li>
	</ul>
	
<li class=p-Steps><p class=Steps>Open the document in the Document 
 Editor.</p></li>
	
<li class=p-Steps><p class=Steps>From the <span style="font-weight: bold;"><B>Format</B></span> 
 menu, select <span style="font-weight: bold;"><B>Document Properties</B></span>. 
 The Document Properties dialog box opens.</p></li>
	
<li class=p-Steps><p class=Steps>Click <span style="font-weight: bold;"><B>Document 
 </B></span>in the list on the left. </p></li>
	
<li class=p-Steps><p class=Steps>Do one of the following:</p></li>
	<ul>
<li class=p-Steps-Bulleted-1><p class=Steps-Bulleted-1>To apply 
 the selections as a filter, select the <span style="font-weight: bold;"><B>Apply 
 selections as a filter for all new targets</B></span> check box.</p></li>
		
<li class=p-Steps-Bulleted-1><p class=Steps-Bulleted-1>To apply 
 the selections as a slice, clear the <span style="font-weight: bold;"><B>Apply 
 selections as a filter for all new targets</B></span> check box.</p></li>
	</ul>
	
<li class=p-Steps><p class=Steps>Click <font style="font-weight: bold;">OK</font> 
 to return to the document.</p></li>
</ol>
<p class=Tip-Note-Heading>Related topics</p>
<ul>
<li class=p-First-Bullet-Do-Not-Type-Text><p class=First-Bullet-Do-Not-Type-Text>&nbsp;</p></li>
	
<li class=p-Topic-Text-Bulleted><p class=Topic-Text-Bulleted>
<a href="Selectors.htm">Providing 
 interactivity to users: Selectors</a></p></li>
	
<li class=p-Topic-Text-Bulleted><p class=Topic-Text-Bulleted>
<a href="Defining_a_selector.htm">Defining 
 selectors</a></p></li>
	
<li class=p-Topic-Text-Bulleted><p class=Topic-Text-Bulleted>
<a href="Insert_a_selector.htm">Adding 
 a selector to a document</a></p></li>
</ul>
<script type="text/javascript" language="javascript1.2">
<!--
highlightSearch();
if (window.writeIntopicBar)
	writeIntopicBar(0);
if(0)
{

}
//-->
</script>
</body>
</html>
